1 -- phpMyAdmin SQL Dump
2 -- version 4.2.11
3 -- http://www.phpmyadmin.net
4 --
5 -- Host: 127.0.0.1
6 -- Generation Time: Apr 11, 2017 at 06:48 AM
7 -- Server version: 5.6.21
8 -- PHP Version: 5.6.3
9
10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11 SET time_zone = "+00:00";
12
13
14 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17 /*!40101 SET NAMES utf8 */;
18
19 --
20 -- Database: `ebuybd`
21 --
22
23 -- --------------------------------------------------------
24
25 --
26 -- Table structure for table `admin`
27 --
28
29 CREATE TABLE IF NOT EXISTS `admin` (
30 `id` int(11) NOT NULL,
31 `firstName` varchar(125) NOT NULL,
32 `lastName` varchar(125) NOT NULL,
33 `email` varchar(100) NOT NULL,
34 `mobile` varchar(25) NOT NULL,
35 `address` text NOT NULL,
36 `password` varchar(100) NOT NULL,
37 `type` varchar(20) NOT NULL,
38 `confirmCode` varchar(10) NOT NULL
39 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
40
41 --
42 -- Dumping data for table `admin`
43 --
44
45 INSERT INTO `admin` (`id`, `firstName`, `lastName`, `email`, `mobile`, `address`, `password`, `type`, `confirmCode`) VALUES
46 (3, 'Borsha', 'Tasnim', 'borsha@gmail.com', '01678293748', 'Dhaka, Bangladesh', 'aa030295ae26e8acbd3d1c9415a60f12', 'manager', '117631');
47
48 -- --------------------------------------------------------
49
50 --
51 -- Table structure for table `orders`
52 --
53
54 CREATE TABLE IF NOT EXISTS `orders` (
55 `id` int(11) NOT NULL,
56 `uid` int(11) NOT NULL,
57 `pid` int(11) NOT NULL,
58 `quantity` int(11) NOT NULL,
59 `oplace` text NOT NULL,
60 `mobile` varchar(15) NOT NULL,
61 `dstatus` varchar(10) NOT NULL DEFAULT 'no',
62 `odate` date NOT NULL,
63 `ddate` date NOT NULL
64 ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;
65
66 --
67 -- Dumping data for table `orders`
68 --
69
70 INSERT INTO `orders` (`id`, `uid`, `pid`, `quantity`, `oplace`, `mobile`, `dstatus`, `odate`, `ddate`) VALUES
71 (1, 7, 28, 0, 'Manikganj Sadar', '01677531881', 'no', '2017-04-07', '0000-00-00'),
72 (2, 7, 31, 0, 'Nikunja 2, Khilkhet, Dhaka', '01677531881', 'yes', '2017-04-07', '0000-00-00'),
73 (4, 7, 26, 0, 'South Seota, Manikganj Sadar', '01677531881', 'no', '2017-04-07', '0000-00-00'),
74 (9, 7, 44, 1, 'Nikunja 2, Khilkhet, Dhaka', '01677531881', 'no', '2017-04-08', '0000-00-00'),
75 (10, 7, 44, 3, 'Nikunja 2, Khilkhet, Dhaka', '01677531881', 'Yes', '2017-04-08', '0000-00-00'),
76 (13, 7, 11, 2, 'Nikunja 2, Khilkhet, Dhaka', '01677531881', 'Cancel', '2017-04-08', '0000-00-00'),
77 (14, 7, 40, 1, 'Nikunja 2, Khilkhet, Dhaka', '01677531881', 'no', '2017-04-08', '0000-00-00'),
78 (15, 7, 43, 1, 'Nikunja 2, Khilkhet, Dhaka', '01677531881', 'no', '2017-04-08', '0000-00-00'),
79 (16, 7, 29, 3, 'Nikunja 2, Khilkhet, Dhaka', '01677531881', 'no', '2017-04-09', '0000-00-00'),
80 (17, 11, 35, 1, 'Saver, Dhaka', '01678293748', 'no', '2017-04-09', '0000-00-00'),
81 (18, 7, 31, 1, 'Nikunja 2, Khilkhet, Dhaka', '01677531881', 'no', '2017-04-09', '0000-00-00'),
82 (19, 13, 43, 3, 'asdfas', '789', 'Yes', '2017-04-09', '0000-00-00'),
83 (20, 13, 29, 1, 'asdfas', '789', 'Yes', '2017-04-09', '2017-04-14'),
84 (21, 7, 43, 1, 'Nikunja 2, Khilkhet, Dhaka', '01677531881', 'no', '2017-04-09', '0000-00-00'),
85 (22, 11, 45, 1, 'Saver, Dhaka', '01678293748', 'no', '2017-04-09', '0000-00-00'),
86 (23, 11, 32, 1, 'Saver, Dhaka', '01678293748', 'no', '2017-04-10', '0000-00-00'),
87 (24, 11, 32, 1, 'Saver, Dhaka', '01678293748', 'no', '2017-04-10', '0000-00-00'),
88 (25, 11, 51, 1, 'Saver, Dhaka', '01678293748', 'no', '2017-04-10', '0000-00-00'),
89 (26, 11, 29, 2, 'Saver, Dhaka', '01678293748', 'Cancel', '2017-04-10', '0000-00-00'),
90 (27, 7, 43, 1, 'Nikunja 2, Khilkhet, Dhaka', '01677531881', 'no', '2017-04-10', '0000-00-00'),
91 (28, 11, 29, 1, 'Saver, Dhaka', '01678293748', 'no', '2017-04-10', '2017-04-11'),
92 (29, 11, 43, 1, 'Saver, Dhaka', '01678293748', 'no', '2017-04-10', '2017-06-12');
93
94 -- --------------------------------------------------------
95
96 --
97 -- Table structure for table `products`
98 --
99
100 CREATE TABLE IF NOT EXISTS `products` (
101 `id` int(11) NOT NULL,
102 `pName` varchar(100) NOT NULL,
103 `price` int(11) NOT NULL,
104 `description` text NOT NULL,
105 `available` int(11) NOT NULL,
106 `category` varchar(100) NOT NULL,
107 `type` varchar(100) NOT NULL,
108 `item` varchar(100) NOT NULL,
109 `pCode` varchar(20) NOT NULL,
110 `picture` text NOT NULL
111 ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;
112
113 --
114 -- Dumping data for table `products`
115 --
116
117 INSERT INTO `products` (`id`, `pName`, `price`, `description`, `available`, `category`, `type`, `item`, `pCode`, `picture`) VALUES
118 (3, 'Metal-Collar-Bone-Chain-Set', 1200, 'Dekhte khub e sundor', 2, 'women', 'Chain Set', 'ornament', 'SR002', 'Women-Neck-Jewelry-Exaggerated-Metal-Collar-Bone-Chain-Set.jpg'),
119 (4, 'Colors-Women-Embellished-Saree', 1200, 'kichu koilam na', 2, 'women', 'cloathing', 'saree', 'SR002', 'Colors-Women-Embellished-Saree_2.jpg'),
120 (5, 'Colors-Women-Embellished-Sarees', 1200, 'kichu koilam na', 2, 'women', 'cloathing', 'saree', 'SR002', 'Colors-Women-Embellished-Saree_3.jpg'),
121 (6, 'Jewelry-Color-diamond-Love-font', 2000, 'Dekhte khub e sundor', 2, 'women', 'Chain Set', 'ornament', 'SR002', 'Jewelry-Color-created-created-diamond-Love-font-b.jpg'),
122 (7, 'Jewelry-full metal earring', 2000, 'Dekhte khub e sundor', 2, 'women', 'earring', 'ornament', 'SR002', 'earrings-online-for-women-4.jpg'),
123 (10, 'Boutique Saree 1', 1300, 'Osthir mama!', 4, 'women', 'cloathing', 'saree', 'SR001', 'Saree Red Color 1.jpg'),
124 (11, 'fancy-look-attractive-saree-2-original', 1200, 'kichu koilam na', 2, 'women', 'cloathing', 'saree', 'SR002', 'new-designer-fancy-look-attractive-saree-2-original.jpg'),
125 (26, 'Watches-for-women-5', 700, 'সà§à¦¨à§à¦¦à¦°, আকরà§à¦·à¦£à§€à§Ÿ', 2, 'women', 'No', 'watch', 'W234', '1491496755.jpg'),
126 (27, 'Diamond-Setting-Watch-3', 700, '2016-New-Electronic-Style-Women-Dress-New-Fashion-Watches-Imitation-Diamond-Setting-Watch-Casual-Wrist-Watch-3', 3, 'women', 'yes', 'watch', 'W234', '1491496880.jpg'),
127 (28, 'Steel-Bracelet 2', 399, 'Steel-Bracelet-Women-Watches-Designs', 2, 'women', 'no', 'watch', 'W345', '1491496956.jpg'),
128 (29, 'Steel-Bracelet-Women-3', 1000, 'Steel-Bracelet-Women-Watches', 3, 'women', 'yes', 'watch', 'W345', '1491497102.jpg'),
129 (30, 'Right-hand-rings 2', 200, 'Right-hand-rings-collection-ornament-champagne-diamond-ring-for-women_mainro', 3, 'women', 'ok', 'ornament', 'O234', '1491497201.jpg'),
130 (31, 'floral-ornament-ring-3d', 1200, 'floral-ornament-ring-3d-model-stl-3dm', 3, 'women', 'ok', 'ornament', 'O254', '1491497263.jpg'),
131 (32, 'Nekles set', 799, 'Good, Awesome', 2, 'women', 'no', 'ornament', 'O2352', '1491497316.jpg'),
132 (33, 'T Shirt 1', 250, 'Nice', 10, 'women', 'no', 'tshirt', 'TS252', '1491497478.jpg'),
133 (34, 'T Shirt 2', 400, 'Nice Looking', 12, 'women', 'no', 'tshirt', 'TS3463', '1491497528.jpg'),
134 (35, 'T Shirt 3', 299, 'Nice', 27, 'women', 'no', 'tshirt', 'TS345', '1491497588.jpg'),
135 (36, 'T Shirt 4', 890, 'Nice, good', 30, 'women', 'no', 'tshirt', 'TS2354', '1491497644.jpg'),
136 (37, 'CHARCOAL_SOFT_G_HIJAB', 700, 'CHARCOAL_SOFT_G_HIJAB', 3, 'women', 'no', 'hijab', 'H98', '1491498074.jpg'),
137 (38, 'HijabScarf (20)', 400, 'HijabScarf ', 23, 'women', 'no', 'hijab', 'H3254', '1491498134.JPG'),
138 (39, 'Hijab 3', 600, 'hijab-2013', 20, 'women', 'no', 'hijab', 'H2354', '1491498202.jpg'),
139 (40, 'Hijab 4', 800, 'nice and cool', 23, 'women', 'no', 'hijab', 'H233', '1491498250.jpg'),
140 (41, 'vera_wang_princess', 2000, 'vera_wang_princess_perfume_for_women', 10, 'women', 'no', 'perfume', 'P2354', '1491498354.jpg'),
141 (42, 'Perfume 1', 150, 'top-perfumes-for-women', 2, 'women', 'no', 'perfume', 'P345', '1491498398.jpg'),
142 (43, 'Perfume 2', 3000, 'Awesome smell', 6, 'women', 'no', 'perfume', 'P252', '1491649246.jpg'),
143 (44, 'Perfume 3', 5000, 'Nice', 3, 'women', 'no', 'perfume', 'P254', '1491498508.jpg'),
144 (45, 'Latest-Fancy 2', 5000, 'Latest-Fancy-Ladiess-Shoes-Designs-2014', 300, 'kidsmom', 'clothing', 'footwear', 'S32543', '1491498848.jpg'),
145 (49, 'Soap 1', 80, 'Nice', 20, 'women', 'no', 'toiletry', 'SP234', '1491499503.jpg'),
146 (51, 'New Perfume 4', 4453, 'asdfa', 34, 'women', 'clothing', 'watch', 'asdf78', '1491707164.jpg'),
147 (52, 'Sareesf', 453354, 'asdfa', 342, 'women', 'clothing', 'perfume', 'S56', '1491850298.jpg'),
148 (53, 'Soap 3', 345, 'Cool', 30, 'women', 'clothing', 'toiletry', 'S789', '1491850339.jpg');
149
150 -- --------------------------------------------------------
151
152 --
153 -- Table structure for table `user`
154 --
155
156 CREATE TABLE IF NOT EXISTS `user` (
157 `id` int(11) NOT NULL,
158 `firstName` varchar(25) NOT NULL,
159 `lastName` varchar(25) NOT NULL,
160 `email` varchar(100) NOT NULL,
161 `mobile` varchar(20) NOT NULL,
162 `address` varchar(120) NOT NULL,
163 `password` varchar(100) NOT NULL,
164 `confirmCode` varchar(10) NOT NULL,
165 `activation` varchar(10) NOT NULL DEFAULT 'no'
166 ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
167
168 --
169 -- Dumping data for table `user`
170 --
171
172 INSERT INTO `user` (`id`, `firstName`, `lastName`, `email`, `mobile`, `address`, `password`, `confirmCode`, `activation`) VALUES
173 (9, 'Borsha', 'Tanjina', 'Tanjina@gmail.com', '01578399283', 'Dhaka, Bangladesh', 'aa030295ae26e8acbd3d1c9415a60f12', '217576', 'yes'),
174 (10, 'Trisha', 'Rehman', 'trisha@gmail.com', '01923457834', 'Mirpur 2, Dhaka', '5af7a513a7c48f6cc97253254b29509b', '0', 'yes'),
175 (11, 'Akhi', 'Alam', 'akhi@gmail.com', '01678293748', 'Saver, Dhaka', 'ca52febd8be7c4480ae90cdae8438a03', '0', 'yes');
176
177 --
178 -- Indexes for dumped tables
179 --
180
181 --
182 -- Indexes for table `admin`
183 --
184 ALTER TABLE `admin`
185 ADD PRIMARY KEY (`id`);
186
187 --
188 -- Indexes for table `orders`
189 --
190 ALTER TABLE `orders`
191 ADD PRIMARY KEY (`id`);
192
193 --
194 -- Indexes for table `products`
195 --
196 ALTER TABLE `products`
197 ADD PRIMARY KEY (`id`);
198
199 --
200 -- Indexes for table `user`
201 --
202 ALTER TABLE `user`
203 ADD PRIMARY KEY (`id`);
204
205 --
206 -- AUTO_INCREMENT for dumped tables
207 --
208
209 --
210 -- AUTO_INCREMENT for table `admin`
211 --
212 ALTER TABLE `admin`
213 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
214 --
215 -- AUTO_INCREMENT for table `orders`
216 --
217 ALTER TABLE `orders`
218 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=30;
219 --
220 -- AUTO_INCREMENT for table `products`
221 --
222 ALTER TABLE `products`
223 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=54;
224 --
225 -- AUTO_INCREMENT for table `user`
226 --
227 ALTER TABLE `user`
228 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
229 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
230 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
231 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;